package w83a.w83aDAO.w83aConstantesBD;

public class W83aLotesPreavisosBD{
	
	public static String lotesPreavisosTable = "W83B07S00";
	public static String sindicatosTable = "W83B19S00";
	public static String provinciasTable = "T17I.T17_PROVINCIA";
	public static String preavisosTable = "W83B08S00";
	public static String municipiosTable = "T17I.T17_MUNICIPIO";
	
	//TABLA 7
	public static String codLote = "LOTE_007";
	public static String nombreFichero = "N_FICHERO_IDA_007";
	public static String nombreFicheroVuelta = "N_FICHERO_VUELTA_007";
	public static String codTerrit = "C_TERRIT_007";
	public static String numPreavisos = "N_PREAVISOS_007";
	public static String fechaEntrada = "F_ENTRADA_007";
	public static String tratado = "TRATADO_007";
	public static String codSindi07 = "C_SINDI_007";
	public static String correlativo = "CORREL_007";
	public static String fechaCreacion = "F_CREACION_007";
	public static String ficheroIda = "FICHERO_IDA_007";
	public static String dni = "DNI_007";
	public static String centrosAfect7 = "N_CENAFEC_007";
	public static String numReg7 = "N_REGIS_007";
	public static String fechaReg7 = "F_REGIS_007";
	public static String firma = "FIRMA_007";
	public static String numTrab7 = "N_TRABAJ_007";
	public static String ficheroVuelta = "FICHERO_VUELTA_007";
	public static String firmado = "FIRMADO_007";
	
	//TABLA PROVINCIA
	public static String territorio = "DS_O";
	public static String id = "ID";
	
	//TABLA 19
	public static String siglasSindi19 = "SIGLAS_019";
	public static String codSindi19 = "C_SINDI_019";
	public static String descSindi = "DESC_019";
	public static String descSindiEus = "DESE_019";

	//TABLA 8
	public static String idPreaviso8 = "PREAVISO_008";
	public static String cif = "CIF_008";
	public static String razonSocial = "RAZ_SOCIAL_008";
	public static String domicilio = "DOMIC_008";
	public static String territorio8 = "C_TERRIT_008";
	public static String provincia8 = "PROV_008";
	public static String municipio8 = "MUNIC_008";
	public static String fechaInicio = "F_INICIO_008";
	public static String centrosAfect = "N_CENAFEC_008";
	public static String codLote8 = "LOTE_008";
	public static String codPostal8 = "CODPOS_008";
	public static String telefono8 = "TELEFONO_008";
	public static String fax8 = "FAX_008";
	public static String email8 = "EMAIL_008";
	public static String cnae8 = "CNAE_008";
	public static String codConvenio8 = "C_CONV_008";
	public static String parcial8 = "S_PARCIAL_008";
	public static String global8 = "GLOBAL_008";
	public static String admonEmp8 = "ADMONEMP_008";
	public static String codSindi8 = "C_SINDI_PROM_008";
	public static String numReg8 = "N_REGIS_008";
	public static String fechaReg8 = "F_REGIS_008";
	public static String preaviso8 = "N_PREAVISO_008";
	public static String id8 = "PREAVISO_008";
	public static String anyopreaviso8 = "ANO_PREAVISO_008";
	public static String ident8 = "IDENT_008";
	public static String observaciones8 = "OBSERV_008";
	public static String estado8 = "ESTADO_008";
	public static String tipo8 = "TIPO_008";
	public static String tipoIden8 = "TIPO_IDEN_008";
	public static String thSS8 = "TH_SS_008";
	public static String numSS8 = "N_SS_008";
	public static String ctrlSS8 = "CTRL_SS_008";
	public static String numTrab8 = "N_TRABAJ_008";
	public static String codSindiMulti8 = "C_SINDI_PROM_MULTI_008";

	public static String provincia = "provincia_id";

	
	
	
}